Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 49894 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.3 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 9 |
|---|---|
| DateTime | 2 |
| Categorical | 2 |
| Boolean | 1 |
staff_id is highly overall correlated with sales_outlet_id | High correlation |
customer_id is highly overall correlated with sales_outlet_id | High correlation |
line_item_id is highly overall correlated with product_id | High correlation |
product_id is highly overall correlated with line_item_id | High correlation |
quantity is highly overall correlated with line_item_amount | High correlation |
line_item_amount is highly overall correlated with quantity and 1 other fields | High correlation |
unit_price is highly overall correlated with line_item_amount | High correlation |
sales_outlet_id is highly overall correlated with staff_id and 1 other fields | High correlation |
promo_item_yn is highly imbalanced (92.0%) | Imbalance |
line_item_amount is highly skewed (γ1 = 42.89584499) | Skewed |
customer_id has 25033 (50.2%) zeros | Zeros |
Reproduction
| Analysis started | 2023-08-02 23:57:27.386211 |
|---|---|
| Analysis finished | 2023-08-02 23:58:13.176663 |
| Duration | 45.79 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
transaction_id
Real number (ℝ)
| Distinct | 4203 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 869.05606 |
| Minimum | 1 |
|---|---|
| Maximum | 4203 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 45 |
| Q1 | 223 |
| median | 481 |
| Q3 | 1401 |
| 95-th percentile | 2487.35 |
| Maximum | 4203 |
| Range | 4202 |
| Interquartile range (IQR) | 1178 |
Descriptive statistics
| Standard deviation | 857.86315 |
|---|---|
| Coefficient of variation (CV) | 0.98712061 |
| Kurtosis | 1.3597398 |
| Mean | 869.05606 |
| Median Absolute Deviation (MAD) | 372 |
| Skewness | 1.3185563 |
| Sum | 43360683 |
| Variance | 735929.18 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 97 | 67 | 0.1% |
| 49 | 66 | 0.1% |
| 45 | 65 | 0.1% |
| 274 | 65 | 0.1% |
| 252 | 64 | 0.1% |
| 319 | 64 | 0.1% |
| 179 | 64 | 0.1% |
| 36 | 63 | 0.1% |
| 177 | 63 | 0.1% |
| 324 | 63 | 0.1% |
| Other values (4193) | 49250 |
| Value | Count | Frequency (%) |
| 1 | 57 | |
| 2 | 54 | |
| 3 | 59 | |
| 4 | 54 | |
| 5 | 62 | |
| 6 | 56 | |
| 7 | 55 | |
| 8 | 56 | |
| 9 | 59 | |
| 10 | 57 |
| Value | Count | Frequency (%) |
| 4203 | 1 | |
| 4202 | 1 | |
| 4201 | 1 | |
| 4200 | 1 | |
| 4199 | 1 | |
| 4198 | 1 | |
| 4197 | 1 | |
| 4196 | 1 | |
| 4195 | 2 | |
| 4194 | 1 |
transaction_date
Date
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 389.9 KiB |
| Minimum | 2019-04-01 00:00:00 |
|---|---|
| Maximum | 2019-04-29 00:00:00 |
transaction_time
Date
| Distinct | 26074 |
|---|---|
| Distinct (%) | 52.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 389.9 KiB |
| Minimum | 2023-08-02 01:00:44 |
|---|---|
| Maximum | 2023-08-02 20:59:32 |
sales_outlet_id
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 389.9 KiB |
| 8 | |
|---|---|
| 3 | |
| 5 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49894 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 8 | 17071 | |
| 3 | 16829 | |
| 5 | 15994 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 8 | 17071 | |
| 3 | 16829 | |
| 5 | 15994 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8 | 17071 | |
| 3 | 16829 | |
| 5 | 15994 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 49894 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 17071 | |
| 3 | 16829 | |
| 5 | 15994 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 49894 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 8 | 17071 | |
| 3 | 16829 | |
| 5 | 15994 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49894 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8 | 17071 | |
| 3 | 16829 | |
| 5 | 15994 |
staff_id
Real number (ℝ)
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.359582 |
| Minimum | 6 |
|---|---|
| Maximum | 45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 15 |
| median | 26 |
| Q3 | 41 |
| 95-th percentile | 45 |
| Maximum | 45 |
| Range | 39 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 12.46649 |
|---|---|
| Coefficient of variation (CV) | 0.49158894 |
| Kurtosis | -1.2641419 |
| Mean | 25.359582 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.34018302 |
| Sum | 1265291 |
| Variance | 155.41338 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 5930 | 11.9% |
| 42 | 4085 | 8.2% |
| 45 | 3648 | 7.3% |
| 26 | 3629 | 7.3% |
| 16 | 3198 | 6.4% |
| 20 | 3127 | 6.3% |
| 17 | 3059 | 6.1% |
| 14 | 2770 | 5.6% |
| 30 | 2430 | 4.9% |
| 44 | 2349 | 4.7% |
| Other values (15) | 15669 |
| Value | Count | Frequency (%) |
| 6 | 1629 | 3.3% |
| 7 | 633 | 1.3% |
| 8 | 306 | 0.6% |
| 9 | 380 | 0.8% |
| 10 | 194 | 0.4% |
| 12 | 5930 | |
| 13 | 90 | 0.2% |
| 14 | 2770 | |
| 15 | 2034 | 4.1% |
| 16 | 3198 |
| Value | Count | Frequency (%) |
| 45 | 3648 | |
| 44 | 2349 | |
| 43 | 2140 | |
| 42 | 4085 | |
| 41 | 1204 | 2.4% |
| 30 | 2430 | |
| 29 | 2112 | |
| 28 | 1751 | |
| 27 | 2063 | |
| 26 | 3629 |
customer_id
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 2248 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2282.3245 |
| Minimum | 0 |
|---|---|
| Maximum | 8501 |
| Zeros | 25033 |
| Zeros (%) | 50.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5412 |
| 95-th percentile | 8342 |
| Maximum | 8501 |
| Range | 8501 |
| Interquartile range (IQR) | 5412 |
Descriptive statistics
| Standard deviation | 3240.5518 |
|---|---|
| Coefficient of variation (CV) | 1.4198471 |
| Kurtosis | -0.90040729 |
| Mean | 2282.3245 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.92450401 |
| Sum | 1.138743 × 108 |
| Variance | 10501176 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 25033 | |
| 3 | 31 | 0.1% |
| 548 | 31 | 0.1% |
| 8285 | 31 | 0.1% |
| 8341 | 29 | 0.1% |
| 8009 | 28 | 0.1% |
| 8118 | 28 | 0.1% |
| 8036 | 28 | 0.1% |
| 8158 | 28 | 0.1% |
| 8101 | 27 | 0.1% |
| Other values (2238) | 24600 |
| Value | Count | Frequency (%) |
| 0 | 25033 | |
| 1 | 8 | < 0.1% |
| 2 | 21 | < 0.1% |
| 3 | 31 | 0.1% |
| 4 | 9 | < 0.1% |
| 5 | 6 | < 0.1% |
| 6 | 12 | < 0.1% |
| 7 | 11 | < 0.1% |
| 8 | 13 | < 0.1% |
| 9 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 8501 | 6 | < 0.1% |
| 8500 | 21 | |
| 8499 | 12 | |
| 8498 | 9 | |
| 8497 | 12 | |
| 8496 | 14 | |
| 8495 | 17 | |
| 8494 | 18 | |
| 8493 | 16 | |
| 8492 | 21 |
instore_yn
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 389.9 KiB |
| Y | |
|---|---|
| N | |
| 294 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 49894 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | Y |
| 4th row | N |
| 5th row | Y |
Common Values
| Value | Count | Frequency (%) |
| Y | 24992 | |
| N | 24608 | |
| 294 | 0.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| y | 24992 | |
| n | 24608 |
Most occurring characters
| Value | Count | Frequency (%) |
| Y | 24992 | |
| N | 24608 | |
| 294 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 49600 | |
| Space Separator | 294 | 0.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| Y | 24992 | |
| N | 24608 |
Space Separator
| Value | Count | Frequency (%) |
| 294 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49600 | |
| Common | 294 | 0.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| Y | 24992 | |
| N | 24608 |
Common
| Value | Count | Frequency (%) |
| 294 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49894 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| Y | 24992 | |
| N | 24608 | |
| 294 | 0.6% |
order
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1734277 |
| Minimum | 1 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.0254447 |
|---|---|
| Coefficient of variation (CV) | 0.87388832 |
| Kurtosis | 35.05642 |
| Mean | 1.1734277 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.9891027 |
| Sum | 58547 |
| Variance | 1.0515369 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 48387 | |
| 7 | 916 | 1.8% |
| 9 | 253 | 0.5% |
| 6 | 132 | 0.3% |
| 2 | 83 | 0.2% |
| 5 | 61 | 0.1% |
| 3 | 56 | 0.1% |
| 8 | 4 | < 0.1% |
| 4 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 48387 | |
| 2 | 83 | 0.2% |
| 3 | 56 | 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 61 | 0.1% |
| 6 | 132 | 0.3% |
| 7 | 916 | 1.8% |
| 8 | 4 | < 0.1% |
| 9 | 253 | 0.5% |
| Value | Count | Frequency (%) |
| 9 | 253 | 0.5% |
| 8 | 4 | < 0.1% |
| 7 | 916 | 1.8% |
| 6 | 132 | 0.3% |
| 5 | 61 | 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 56 | 0.1% |
| 2 | 83 | 0.2% |
| 1 | 48387 |
line_item_id
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6318595 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.4128807 |
|---|---|
| Coefficient of variation (CV) | 0.86581024 |
| Kurtosis | 2.6969449 |
| Mean | 1.6318595 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.0433121 |
| Sum | 81420 |
| Variance | 1.9962319 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 39949 | |
| 5 | 6332 | 12.7% |
| 2 | 2547 | 5.1% |
| 3 | 503 | 1.0% |
| 6 | 324 | 0.6% |
| 4 | 177 | 0.4% |
| 9 | 55 | 0.1% |
| 8 | 4 | < 0.1% |
| 12 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 39949 | |
| 2 | 2547 | 5.1% |
| 3 | 503 | 1.0% |
| 4 | 177 | 0.4% |
| 5 | 6332 | 12.7% |
| 6 | 324 | 0.6% |
| 7 | 1 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 55 | 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 12 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 55 | 0.1% |
| 8 | 4 | < 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 324 | 0.6% |
| 5 | 6332 | |
| 4 | 177 | 0.4% |
| 3 | 503 | 1.0% |
| 2 | 2547 |
product_id
Real number (ℝ)
| Distinct | 80 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.878983 |
| Minimum | 1 |
|---|---|
| Maximum | 87 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 33 |
| median | 47 |
| Q3 | 60 |
| 95-th percentile | 78 |
| Maximum | 87 |
| Range | 86 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 17.928355 |
|---|---|
| Coefficient of variation (CV) | 0.37445146 |
| Kurtosis | -0.67144817 |
| Mean | 47.878983 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.19720739 |
| Sum | 2388874 |
| Variance | 321.42592 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 71 | 1034 | 2.1% |
| 50 | 1015 | 2.0% |
| 59 | 1000 | 2.0% |
| 61 | 995 | 2.0% |
| 38 | 993 | 2.0% |
| 29 | 991 | 2.0% |
| 52 | 985 | 2.0% |
| 54 | 984 | 2.0% |
| 26 | 978 | 2.0% |
| 32 | 978 | 2.0% |
| Other values (70) | 39941 |
| Value | Count | Frequency (%) |
| 1 | 69 | |
| 2 | 65 | |
| 3 | 53 | |
| 4 | 47 | |
| 5 | 50 | |
| 6 | 70 | |
| 7 | 51 | |
| 8 | 67 | |
| 9 | 67 | |
| 10 | 48 |
| Value | Count | Frequency (%) |
| 87 | 755 | |
| 84 | 569 | |
| 83 | 97 | 0.2% |
| 82 | 69 | 0.1% |
| 81 | 79 | 0.2% |
| 79 | 677 | |
| 78 | 639 | |
| 77 | 611 | |
| 76 | 622 | |
| 75 | 645 |
quantity
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.438209 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5430387 |
|---|---|
| Coefficient of variation (CV) | 0.37757983 |
| Kurtosis | 1.0970904 |
| Mean | 1.438209 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.82201515 |
| Sum | 71758 |
| Variance | 0.29489103 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 29170 | |
| 2 | 19616 | |
| 3 | 1094 | 2.2% |
| 4 | 9 | < 0.1% |
| 8 | 4 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 29170 | |
| 2 | 19616 | |
| 3 | 1094 | 2.2% |
| 4 | 9 | < 0.1% |
| 6 | 1 | < 0.1% |
| 8 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 8 | 4 | < 0.1% |
| 6 | 1 | < 0.1% |
| 4 | 9 | < 0.1% |
| 3 | 1094 | 2.2% |
| 2 | 19616 | |
| 1 | 29170 |
line_item_amount
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 77 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.6826462 |
| Minimum | 0 |
|---|---|
| Maximum | 360 |
| Zeros | 24 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3.75 |
| Q3 | 6 |
| 95-th percentile | 9 |
| Maximum | 360 |
| Range | 360 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 4.4366683 |
|---|---|
| Coefficient of variation (CV) | 0.94747031 |
| Kurtosis | 3308.2068 |
| Mean | 4.6826462 |
| Median Absolute Deviation (MAD) | 1.25 |
| Skewness | 42.895845 |
| Sum | 233635.95 |
| Variance | 19.684025 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 5916 | 11.9% |
| 6 | 5149 | 10.3% |
| 2.5 | 4376 | 8.8% |
| 5 | 4120 | 8.3% |
| 3.75 | 4109 | 8.2% |
| 3.5 | 3184 | 6.4% |
| 7.5 | 2119 | 4.2% |
| 3.25 | 1992 | 4.0% |
| 4 | 1384 | 2.8% |
| 7 | 1357 | 2.7% |
| Other values (67) | 16188 |
| Value | Count | Frequency (%) |
| 0 | 24 | < 0.1% |
| 0.8 | 1080 | 2.2% |
| 1 | 156 | 0.3% |
| 1.6 | 1130 | 2.3% |
| 2 | 929 | 1.9% |
| 2.1 | 184 | 0.4% |
| 2.2 | 913 | 1.8% |
| 2.4 | 31 | 0.1% |
| 2.45 | 435 | 0.9% |
| 2.5 | 4376 |
| Value | Count | Frequency (%) |
| 360 | 4 | < 0.1% |
| 72 | 1 | < 0.1% |
| 56 | 1 | < 0.1% |
| 45 | 63 | |
| 36 | 1 | < 0.1% |
| 28 | 84 | |
| 24 | 1 | < 0.1% |
| 23 | 12 | < 0.1% |
| 22.5 | 55 | |
| 21 | 70 |
unit_price
Real number (ℝ)
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3846454 |
| Minimum | 0.8 |
|---|---|
| Maximum | 45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 389.9 KiB |
Quantile statistics
| Minimum | 0.8 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2.5 |
| median | 3 |
| Q3 | 3.75 |
| 95-th percentile | 4.5 |
| Maximum | 45 |
| Range | 44.2 |
| Interquartile range (IQR) | 1.25 |
Descriptive statistics
| Standard deviation | 2.6825447 |
|---|---|
| Coefficient of variation (CV) | 0.79256299 |
| Kurtosis | 99.83137 |
| Mean | 3.3846454 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 8.5307304 |
| Sum | 168873.5 |
| Variance | 7.1960461 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 11316 | |
| 2.5 | 8762 | |
| 3.75 | 6214 | |
| 3.5 | 4609 | |
| 0.8 | 2248 | 4.5% |
| 3.25 | 2023 | 4.1% |
| 2.2 | 1904 | 3.8% |
| 4.25 | 1903 | 3.8% |
| 2 | 1877 | 3.8% |
| 3.1 | 1862 | 3.7% |
| Other values (31) | 7176 |
| Value | Count | Frequency (%) |
| 0.8 | 2248 | 4.5% |
| 2 | 1877 | 3.8% |
| 2.1 | 256 | 0.5% |
| 2.2 | 1904 | 3.8% |
| 2.45 | 883 | 1.8% |
| 2.5 | 8762 | |
| 2.55 | 907 | 1.8% |
| 2.65 | 96 | 0.2% |
| 3 | 11316 | |
| 3.1 | 1862 | 3.7% |
| Value | Count | Frequency (%) |
| 45 | 67 | |
| 28 | 83 | |
| 23 | 12 | < 0.1% |
| 22.5 | 55 | |
| 21 | 70 | |
| 20.45 | 47 | 0.1% |
| 19.75 | 51 | 0.1% |
| 18 | 134 | |
| 15 | 50 | 0.1% |
| 14.75 | 53 | 0.1% |
promo_item_yn
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.8 KiB |
| False | |
|---|---|
| True | 490 |
| Value | Count | Frequency (%) |
| False | 49404 | |
| True | 490 | 1.0% |
| transaction_id | staff_id | customer_id | order | line_item_id | product_id | quantity | line_item_amount | unit_price | sales_outlet_id | instore_yn | promo_item_yn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| transaction_id | 1.000 | 0.002 | 0.042 | -0.061 | -0.071 | -0.043 | 0.021 | 0.021 | -0.007 | 0.202 | 0.048 | 0.036 |
| staff_id | 0.002 | 1.000 | 0.112 | 0.007 | 0.001 | 0.009 | 0.011 | 0.001 | -0.011 | 0.860 | 0.129 | 0.073 |
| customer_id | 0.042 | 0.112 | 1.000 | -0.034 | -0.030 | -0.012 | 0.009 | 0.012 | -0.001 | 0.609 | 0.025 | 0.015 |
| order | -0.061 | 0.007 | -0.034 | 1.000 | -0.020 | -0.154 | -0.141 | 0.245 | 0.274 | 0.063 | 0.005 | 0.012 |
| line_item_id | -0.071 | 0.001 | -0.030 | -0.020 | 1.000 | 0.628 | -0.301 | -0.254 | 0.123 | 0.081 | 0.135 | 0.235 |
| product_id | -0.043 | 0.009 | -0.012 | -0.154 | 0.628 | 1.000 | -0.175 | -0.126 | 0.216 | 0.064 | 0.008 | 0.261 |
| quantity | 0.021 | 0.011 | 0.009 | -0.141 | -0.301 | -0.175 | 1.000 | 0.682 | -0.159 | 0.155 | 0.008 | 0.035 |
| line_item_amount | 0.021 | 0.001 | 0.012 | 0.245 | -0.254 | -0.126 | 0.682 | 1.000 | 0.522 | 0.007 | 0.000 | 0.000 |
| unit_price | -0.007 | -0.011 | -0.001 | 0.274 | 0.123 | 0.216 | -0.159 | 0.522 | 1.000 | 0.027 | 0.012 | 0.012 |
| sales_outlet_id | 0.202 | 0.860 | 0.609 | 0.063 | 0.081 | 0.064 | 0.155 | 0.007 | 0.027 | 1.000 | 0.075 | 0.077 |
| instore_yn | 0.048 | 0.129 | 0.025 | 0.005 | 0.135 | 0.008 | 0.008 | 0.000 | 0.012 | 0.075 | 1.000 | 0.004 |
| promo_item_yn | 0.036 | 0.073 | 0.015 | 0.012 | 0.235 | 0.261 | 0.035 | 0.000 | 0.012 | 0.077 | 0.004 | 1.000 |
| transaction_id | transaction_date | transaction_time | sales_outlet_id | staff_id | customer_id | instore_yn | order | line_item_id | product_id | quantity | line_item_amount | unit_price | promo_item_yn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 7 | 2019-04-01 | 2023-08-02 12:04:43 | 3 | 12 | 558 | N | 1 | 1 | 52 | 1 | 2.50 | 2.50 | N |
| 1 | 11 | 2019-04-01 | 2023-08-02 15:54:39 | 3 | 17 | 781 | N | 1 | 1 | 27 | 2 | 7.00 | 3.50 | N |
| 2 | 19 | 2019-04-01 | 2023-08-02 14:34:59 | 3 | 17 | 788 | Y | 1 | 1 | 46 | 2 | 5.00 | 2.50 | N |
| 3 | 32 | 2019-04-01 | 2023-08-02 16:06:04 | 3 | 12 | 683 | N | 1 | 1 | 23 | 2 | 5.00 | 2.50 | N |
| 4 | 33 | 2019-04-01 | 2023-08-02 19:18:37 | 3 | 17 | 99 | Y | 1 | 1 | 34 | 1 | 2.45 | 2.45 | N |
| 5 | 39 | 2019-04-01 | 2023-08-02 18:54:46 | 3 | 17 | 664 | Y | 1 | 1 | 32 | 1 | 3.00 | 3.00 | N |
| 6 | 50 | 2019-04-01 | 2023-08-02 13:03:49 | 3 | 12 | 316 | N | 1 | 1 | 49 | 2 | 6.00 | 3.00 | N |
| 7 | 53 | 2019-04-01 | 2023-08-02 11:21:14 | 3 | 12 | 38 | N | 1 | 1 | 60 | 1 | 3.75 | 3.75 | N |
| 8 | 59 | 2019-04-01 | 2023-08-02 19:30:55 | 3 | 12 | 370 | Y | 1 | 1 | 51 | 2 | 6.00 | 3.00 | N |
| 9 | 62 | 2019-04-01 | 2023-08-02 12:01:00 | 3 | 12 | 180 | Y | 1 | 1 | 49 | 2 | 6.00 | 3.00 | N |
| transaction_id | transaction_date | transaction_time | sales_outlet_id | staff_id | customer_id | instore_yn | order | line_item_id | product_id | quantity | line_item_amount | unit_price | promo_item_yn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49884 | 742 | 2019-04-29 | 2023-08-02 19:23:25 | 8 | 45 | 0 | N | 1 | 5 | 74 | 1 | 3.50 | 3.50 | N |
| 49885 | 746 | 2019-04-29 | 2023-08-02 15:54:11 | 8 | 15 | 0 | N | 1 | 1 | 37 | 2 | 6.00 | 3.00 | N |
| 49886 | 746 | 2019-04-29 | 2023-08-02 15:54:11 | 8 | 15 | 0 | N | 1 | 5 | 71 | 1 | 3.75 | 3.75 | N |
| 49887 | 749 | 2019-04-29 | 2023-08-02 19:34:50 | 8 | 15 | 0 | N | 1 | 1 | 47 | 1 | 3.00 | 3.00 | N |
| 49888 | 752 | 2019-04-29 | 2023-08-02 16:36:24 | 8 | 42 | 8401 | N | 1 | 1 | 87 | 1 | 2.10 | 2.10 | Y |
| 49889 | 753 | 2019-04-29 | 2023-08-02 16:51:58 | 8 | 42 | 0 | N | 1 | 1 | 30 | 1 | 3.00 | 3.00 | N |
| 49890 | 756 | 2019-04-29 | 2023-08-02 16:51:14 | 8 | 42 | 8412 | Y | 1 | 1 | 25 | 2 | 4.40 | 2.20 | N |
| 49891 | 759 | 2019-04-29 | 2023-08-02 11:17:36 | 8 | 15 | 0 | Y | 1 | 1 | 31 | 1 | 2.20 | 2.20 | N |
| 49892 | 763 | 2019-04-29 | 2023-08-02 15:45:52 | 8 | 45 | 8030 | N | 1 | 1 | 44 | 2 | 5.00 | 2.50 | N |
| 49893 | 763 | 2019-04-29 | 2023-08-02 15:45:52 | 8 | 45 | 8030 | N | 1 | 5 | 75 | 1 | 3.50 | 3.50 | N |